package jnpf.zc.mapper;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import jnpf.zc.entity.ZcglZcdjAreaEntity;
import org.apache.ibatis.annotations.Select;

/**
 *
 * 资产登记
 * 版本： V3.2.0
 * 版权： 智果云科技（https://www.jnpfsoft.com）
 * 作者： JNPF开发平台组
 * 日期： 2024-12-19
 */
public interface ZcglZcdjAreaMapper extends BaseMapper<ZcglZcdjAreaEntity> {
    @Select("SELECT SUM(BUILDING_AREA) FROM zcgl_zcdj_area")
    Double sumBuildingArea();

    @Select("SELECT SUM(LAND_AREA) FROM zcgl_zcdj_area")
    Double sumLandArea();

    @Select("SELECT SUM(SHARED_LAND_AREA) FROM zcgl_zcdj_area")
    Double sumSharedLandArea();

    @Select("SELECT SUM(BUILDING_MEASUREMENT_AREA) FROM zcgl_zcdj_area")
    Double sumBuildingMeasurementArea();

    @Select("SELECT SUM(LAND_SURVEY_AREA) FROM zcgl_zcdj_area")
    Double sumLandSurveyArea();
}
